﻿USE [syncdb]
GO

/****** Object:  Table [dbo].[cust_syncacount]    Script Date: 2022/4/13 14:03:03 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cust_syncacount]') AND type in (N'U'))
DROP TABLE [dbo].[cust_syncacount]
GO

/****** Object:  Table [dbo].[cust_accconfig]    Script Date: 2022/4/13 14:03:03 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cust_accconfig]') AND type in (N'U'))
DROP TABLE [dbo].[cust_accconfig]
GO

/****** Object:  Table [dbo].[cust_accconfig]    Script Date: 2022/4/13 14:03:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[cust_accconfig](
	[accid] [nvarchar](50) NOT NULL,
	[record] [nvarchar](50) NOT NULL,
	[dsynctime] [datetime] NULL,
 CONSTRAINT [PK_cust_accconfig] PRIMARY KEY CLUSTERED 
(
	[accid] ASC,
	[record] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[cust_syncacount]    Script Date: 2022/4/13 14:03:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[cust_syncacount](
	[accname] [varchar](100) NOT NULL,
	[cserver] [varchar](50) NULL,
	[cuser] [varchar](50) NULL,
	[psd] [varchar](50) NULL,
	[dbname] [varchar](50) NULL,
	[flag] [bit] NULL,
	[custid] [varchar](50) NULL,
	[cbill] [varchar](1000) NULL,
	[dsynctime] [datetime] NULL,
	[id] [int] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [PK_cust_syncacount] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO


